package jpa.entitys.promis.common;

import java.io.Serializable;

import javax.persistence.*;

import java.math.BigDecimal;
import java.util.Date;


/**
 * The persistent class for the VW_SYNC_CRNOTE_RENTAL database table.
 * 
 */
@Entity
@Table(name="VW_SYNC_CRNOTE_RENTAL")
@NamedQueries({
    @NamedQuery(name = "VwSyncCrnoteRental.findAll", query = " SELECT c FROM VwSyncCrnoteRental c "),
    @NamedQuery(name = "VwSyncCrnoteRental.findById", query = " SELECT c FROM VwSyncCrnoteRental c WHERE c.syncPkId = :Id "),
    @NamedQuery(name = "VwSyncCrnoteRental.findByStatus", query = " SELECT c FROM VwSyncCrnoteRental c WHERE c.status = :status And c.syncIsstaging = :syncIsstaging "),
    @NamedQuery(name = "VwSyncCrnoteRental.findByDocumentNo", query = " SELECT c FROM VwSyncCrnoteRental c WHERE c.company = :company And c.project =:project And c.documentNo = :documentNo And c.status = :status And c.syncIsstaging = :syncIsstaging")
})
public class VwSyncCrnoteRental extends jpa.entitys.common.CommonEntity implements Serializable {
	private static final long serialVersionUID = 1L;

	@Id
	@Column(name="SYNC_PK_ID", length=100)
	private String syncPkId;
	
	@Override public String toString() { return org.apache.commons.lang.builder.ToStringBuilder.reflectionToString(this);}
	
	@Column(name="CUST_CRNOTE_REFERENCES_ID", length=4000)
	private String custCrnoteReferencesId;
	
	@Column(name="ADDRESS_CODE", precision=2)
	private BigDecimal addressCode;

	@Column(name="CHARGE_CODE", length=2)
	private String chargeCode;

	@Column(nullable=false, length=2)
	private String company;

	@Column(name="CONTRACT_REF_NO", length=4000)
	private String contractRefNo;

	@Column(name="CREATED_BY")
	private String createdBy;

	@Column(name="CREATED_BY_NAME", length=4000)
	private String createdByName;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="CREATED_ON")
	private Date createdOn;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="CREDIT_NOTE_DATE")
	private Date creditNoteDate;

	@Column(name="CREDIT_NOTE_NO", nullable=false, precision=6)
	private Long creditNoteNo;

	@Column(name="CREDIT_NOTE_SEQ", nullable=false, precision=6)
	private BigDecimal creditNoteSeq;

	@Column(name="CREDIT_NOTE_SERIES", nullable=false, length=4)
	private String creditNoteSeries;

	@Column(name="CREDIT_NOTE_TYPE", nullable=false, length=2)
	private String creditNoteType;

	@Column(length=3)
	private String currency;

	@Column(name="CUSTOMER_CODE", length=30)
	private String customerCode;

	@Column(name="CUSTOMER_CREDIT_NOTES_ID", length=4000)
	private String customerCreditNotesId;

	@Column(name="DEPARTMENT_CODE", length=30)
	private String departmentCode;

	@Column(length=4000)
	private String description;

	@Column(name="EXCHANGE_RATE", precision=12, scale=8)
	private BigDecimal exchangeRate;

	@Column(name="INTERFACE_NO", length=4000)
	private String interfaceNo;

	@Column(name="INV_DOC_REF_NO", length=4000)
	private String invDocRefNo;

	@Column(name="INVOICE_CREDIT_AMOUNT", precision=16, scale=2)
	private BigDecimal invoiceCreditAmount;

	@Column(name="INVOICE_NO", precision=6)
	private BigDecimal invoiceNo;

	@Column(name="INVOICE_SEQ", precision=6)
	private BigDecimal invoiceSeq;

	@Column(name="INVOICE_SERIES", length=4)
	private String invoiceSeries;

	@Column(name="INVOICE_TYPE", length=2)
	private String invoiceType;

	@Column(name="LAST_UPD_BY")
	private String lastUpdBy;

	@Column(name="LAST_UPD_BY_NAME", length=4000)
	private String lastUpdByName;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="LAST_UPD_ON")
	private Date lastUpdOn;

	@Column(name="NET_INVOICE_CREDIT_AMOUNT", precision=18, scale=2)
	private BigDecimal netInvoiceCreditAmount;

	@Column(length=30)
	private String project;

	@Column(length=300)
	private String remarks;

	@Column(name="REMARKS_DET", length=300)
	private String remarksDet;

	@Column(name="SAP_COMPANY_CODE", length=4000)
	private String sapCompanyCode;

	@Column(name="SAP_PLANT_CODE", length=4000)
	private String sapPlantCode;

	@Column(name="SERVICE_VAT_FLAG", length=1)
	private String serviceVatFlag;

	@Column(length=1)
	private String status;

	@Column(name="SYNC_CREATEDBY", length=100)
	private String syncCreatedby;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="SYNC_CREATEDON")
	private Date syncCreatedon;

	@Column(name="SYNC_EXTERNAL_REF_KEY", length=100)
	private String syncExternalRefKey;

	@Column(name="SYNC_EXTERNAL_REF_NO", length=100)
	private String syncExternalRefNo;

	@Column(name="SYNC_ISSTAGING", length=1)
	private String syncIsstaging;

	@Column(name="SYNC_ISSYNC", length=1)
	private String syncIssync;

	@Column(name="SYNC_UPDATEDBY", length=100)
	private String syncUpdatedby;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="SYNC_UPDATEDON")
	private Date syncUpdatedon;

	@Column(name="TAX_RATE", precision=5, scale=2)
	private BigDecimal taxRate;

	@Column(name="TAX_TYPE", length=2)
	private String taxType;

	@Column(name="TAX_TYPE_CODE", length=2)
	private String taxTypeCode;

	@Column(name="UNIT_CONTRACT_REF_NO", length=4000)
	private String unitContractRefNo;

	@Column(name="UNIT_NUMBER", length=30)
	private String unitNumber;

	@Column(name="VAT_BASE_CREDIT_AMOUNT", precision=16, scale=2)
	private BigDecimal vatBaseCreditAmount;

	@Column(name="VAT_CREDIT_AMOUNT", precision=16, scale=2)
	private BigDecimal vatCreditAmount;

	@Column(precision=22)
	private BigDecimal wht;

	@Column(name="WHT_AMOUNT", precision=16, scale=2)
	private BigDecimal whtAmount;

	@Column(name="WHT_BASE_AMOUNT", precision=16, scale=2)
	private BigDecimal whtBaseAmount;

	@Column(name="WHT_PERCENT", precision=5, scale=2)
	private BigDecimal whtPercent;
	
	@Column(name="DOCUMENT_NO")
	private String documentNo;
	
	@Column(name="REF_TAX_DOCUMENT")
	private String refTaxDocument;

	public String getRefTaxDocument() {
		return refTaxDocument;
	}

	public void setRefTaxDocument(String refTaxDocument) {
		this.refTaxDocument = refTaxDocument;
	}

	/**
	 * @return the syncPkId
	 */
	public String getSyncPkId() {
		return syncPkId;
	}

	/**
	 * @param syncPkId the syncPkId to set
	 */
	public void setSyncPkId(String syncPkId) {
		this.syncPkId = syncPkId;
	}

	/**
	 * @return the documentNo
	 */
	public String getDocumentNo() {
		return documentNo;
	}	

	/**
	 * @param documentNo the documentNo to set
	 */
	public void setDocumentNo(String documentNo) {
		this.documentNo = documentNo;
	}

    public VwSyncCrnoteRental() {
    }

	public BigDecimal getAddressCode() {
		return this.addressCode;
	}

	public void setAddressCode(BigDecimal addressCode) {
		this.addressCode = addressCode;
	}

	public String getChargeCode() {
		return this.chargeCode;
	}

	public void setChargeCode(String chargeCode) {
		this.chargeCode = chargeCode;
	}

	public String getCompany() {
		return this.company;
	}

	public void setCompany(String company) {
		this.company = company;
	}

	public String getContractRefNo() {
		return this.contractRefNo;
	}

	public void setContractRefNo(String contractRefNo) {
		this.contractRefNo = contractRefNo;
	}

	public String getCreatedBy() {
		return this.createdBy;
	}

	public void setCreatedBy(String createdBy) {
		this.createdBy = createdBy;
	}

	public String getCreatedByName() {
		return this.createdByName;
	}

	public void setCreatedByName(String createdByName) {
		this.createdByName = createdByName;
	}

	public Date getCreatedOn() {
		return this.createdOn;
	}

	public void setCreatedOn(Date createdOn) {
		this.createdOn = createdOn;
	}

	public Date getCreditNoteDate() {
		return this.creditNoteDate;
	}

	public void setCreditNoteDate(Date creditNoteDate) {
		this.creditNoteDate = creditNoteDate;
	}

	public Long getCreditNoteNo() {
		return this.creditNoteNo;
	}

	public void setCreditNoteNo(Long creditNoteNo) {
		this.creditNoteNo = creditNoteNo;
	}

	public BigDecimal getCreditNoteSeq() {
		return this.creditNoteSeq;
	}

	public void setCreditNoteSeq(BigDecimal creditNoteSeq) {
		this.creditNoteSeq = creditNoteSeq;
	}

	public String getCreditNoteSeries() {
		return this.creditNoteSeries;
	}

	public void setCreditNoteSeries(String creditNoteSeries) {
		this.creditNoteSeries = creditNoteSeries;
	}

	public String getCreditNoteType() {
		return this.creditNoteType;
	}

	public void setCreditNoteType(String creditNoteType) {
		this.creditNoteType = creditNoteType;
	}

	public String getCurrency() {
		return this.currency;
	}

	public void setCurrency(String currency) {
		this.currency = currency;
	}

	public String getCustCrnoteReferencesId() {
		return this.custCrnoteReferencesId;
	}

	public void setCustCrnoteReferencesId(String custCrnoteReferencesId) {
		this.custCrnoteReferencesId = custCrnoteReferencesId;
	}

	public String getCustomerCode() {
		return this.customerCode;
	}

	public void setCustomerCode(String customerCode) {
		this.customerCode = customerCode;
	}

	public String getCustomerCreditNotesId() {
		return this.customerCreditNotesId;
	}

	public void setCustomerCreditNotesId(String customerCreditNotesId) {
		this.customerCreditNotesId = customerCreditNotesId;
	}

	public String getDepartmentCode() {
		return this.departmentCode;
	}

	public void setDepartmentCode(String departmentCode) {
		this.departmentCode = departmentCode;
	}

	public String getDescription() {
		return this.description;
	}

	public void setDescription(String description) {
		this.description = description;
	}

	public BigDecimal getExchangeRate() {
		return this.exchangeRate;
	}

	public void setExchangeRate(BigDecimal exchangeRate) {
		this.exchangeRate = exchangeRate;
	}

	public String getInterfaceNo() {
		return this.interfaceNo;
	}

	public void setInterfaceNo(String interfaceNo) {
		this.interfaceNo = interfaceNo;
	}

	public String getInvDocRefNo() {
		return this.invDocRefNo;
	}

	public void setInvDocRefNo(String invDocRefNo) {
		this.invDocRefNo = invDocRefNo;
	}

	public BigDecimal getInvoiceCreditAmount() {
		return this.invoiceCreditAmount;
	}

	public void setInvoiceCreditAmount(BigDecimal invoiceCreditAmount) {
		this.invoiceCreditAmount = invoiceCreditAmount;
	}

	public BigDecimal getInvoiceNo() {
		return this.invoiceNo;
	}

	public void setInvoiceNo(BigDecimal invoiceNo) {
		this.invoiceNo = invoiceNo;
	}

	public BigDecimal getInvoiceSeq() {
		return this.invoiceSeq;
	}

	public void setInvoiceSeq(BigDecimal invoiceSeq) {
		this.invoiceSeq = invoiceSeq;
	}

	public String getInvoiceSeries() {
		return this.invoiceSeries;
	}

	public void setInvoiceSeries(String invoiceSeries) {
		this.invoiceSeries = invoiceSeries;
	}

	public String getInvoiceType() {
		return this.invoiceType;
	}

	public void setInvoiceType(String invoiceType) {
		this.invoiceType = invoiceType;
	}

	public String getLastUpdBy() {
		return this.lastUpdBy;
	}

	public void setLastUpdBy(String lastUpdBy) {
		this.lastUpdBy = lastUpdBy;
	}

	public String getLastUpdByName() {
		return this.lastUpdByName;
	}

	public void setLastUpdByName(String lastUpdByName) {
		this.lastUpdByName = lastUpdByName;
	}

	public Date getLastUpdOn() {
		return this.lastUpdOn;
	}

	public void setLastUpdOn(Date lastUpdOn) {
		this.lastUpdOn = lastUpdOn;
	}

	public BigDecimal getNetInvoiceCreditAmount() {
		return this.netInvoiceCreditAmount;
	}

	public void setNetInvoiceCreditAmount(BigDecimal netInvoiceCreditAmount) {
		this.netInvoiceCreditAmount = netInvoiceCreditAmount;
	}

	public String getProject() {
		return this.project;
	}

	public void setProject(String project) {
		this.project = project;
	}

	public String getRemarks() {
		return this.remarks;
	}

	public void setRemarks(String remarks) {
		this.remarks = remarks;
	}

	public String getRemarksDet() {
		return this.remarksDet;
	}

	public void setRemarksDet(String remarksDet) {
		this.remarksDet = remarksDet;
	}

	public String getSapCompanyCode() {
		return this.sapCompanyCode;
	}

	public void setSapCompanyCode(String sapCompanyCode) {
		this.sapCompanyCode = sapCompanyCode;
	}

	public String getSapPlantCode() {
		return this.sapPlantCode;
	}

	public void setSapPlantCode(String sapPlantCode) {
		this.sapPlantCode = sapPlantCode;
	}

	public String getServiceVatFlag() {
		return this.serviceVatFlag;
	}

	public void setServiceVatFlag(String serviceVatFlag) {
		this.serviceVatFlag = serviceVatFlag;
	}

	public String getStatus() {
		return this.status;
	}

	public void setStatus(String status) {
		this.status = status;
	}

	public String getSyncCreatedby() {
		return this.syncCreatedby;
	}

	public void setSyncCreatedby(String syncCreatedby) {
		this.syncCreatedby = syncCreatedby;
	}

	public Date getSyncCreatedon() {
		return this.syncCreatedon;
	}

	public void setSyncCreatedon(Date syncCreatedon) {
		this.syncCreatedon = syncCreatedon;
	}

	public String getSyncExternalRefKey() {
		return this.syncExternalRefKey;
	}

	public void setSyncExternalRefKey(String syncExternalRefKey) {
		this.syncExternalRefKey = syncExternalRefKey;
	}

	public String getSyncExternalRefNo() {
		return this.syncExternalRefNo;
	}

	public void setSyncExternalRefNo(String syncExternalRefNo) {
		this.syncExternalRefNo = syncExternalRefNo;
	}

	public String getSyncIsstaging() {
		return this.syncIsstaging;
	}

	public void setSyncIsstaging(String syncIsstaging) {
		this.syncIsstaging = syncIsstaging;
	}

	public String getSyncIssync() {
		return this.syncIssync;
	}

	public void setSyncIssync(String syncIssync) {
		this.syncIssync = syncIssync;
	}

	public String getSyncUpdatedby() {
		return this.syncUpdatedby;
	}

	public void setSyncUpdatedby(String syncUpdatedby) {
		this.syncUpdatedby = syncUpdatedby;
	}

	public Date getSyncUpdatedon() {
		return this.syncUpdatedon;
	}

	public void setSyncUpdatedon(Date syncUpdatedon) {
		this.syncUpdatedon = syncUpdatedon;
	}

	public BigDecimal getTaxRate() {
		return this.taxRate;
	}

	public void setTaxRate(BigDecimal taxRate) {
		this.taxRate = taxRate;
	}

	public String getTaxType() {
		return this.taxType;
	}

	public void setTaxType(String taxType) {
		this.taxType = taxType;
	}

	public String getTaxTypeCode() {
		return this.taxTypeCode;
	}

	public void setTaxTypeCode(String taxTypeCode) {
		this.taxTypeCode = taxTypeCode;
	}

	public String getUnitContractRefNo() {
		return this.unitContractRefNo;
	}

	public void setUnitContractRefNo(String unitContractRefNo) {
		this.unitContractRefNo = unitContractRefNo;
	}

	public String getUnitNumber() {
		return this.unitNumber;
	}

	public void setUnitNumber(String unitNumber) {
		this.unitNumber = unitNumber;
	}

	public BigDecimal getVatBaseCreditAmount() {
		return this.vatBaseCreditAmount;
	}

	public void setVatBaseCreditAmount(BigDecimal vatBaseCreditAmount) {
		this.vatBaseCreditAmount = vatBaseCreditAmount;
	}

	public BigDecimal getVatCreditAmount() {
		return this.vatCreditAmount;
	}

	public void setVatCreditAmount(BigDecimal vatCreditAmount) {
		this.vatCreditAmount = vatCreditAmount;
	}

	public BigDecimal getWht() {
		return this.wht;
	}

	public void setWht(BigDecimal wht) {
		this.wht = wht;
	}

	public BigDecimal getWhtAmount() {
		return this.whtAmount;
	}

	public void setWhtAmount(BigDecimal whtAmount) {
		this.whtAmount = whtAmount;
	}

	public BigDecimal getWhtBaseAmount() {
		return this.whtBaseAmount;
	}

	public void setWhtBaseAmount(BigDecimal whtBaseAmount) {
		this.whtBaseAmount = whtBaseAmount;
	}

	public BigDecimal getWhtPercent() {
		return this.whtPercent;
	}

	public void setWhtPercent(BigDecimal whtPercent) {
		this.whtPercent = whtPercent;
	}

}